Mega Code Archive

Categories
1) Android
2) ASP.Net
3) ASP.Net Tutorial
4) C
5) C Tutorial
6) C#
7) C# Book
8) C# by API
9) C# Tutorial
10) C++
11) C++ Tutorial
12) Delphi
13) Flash ActionScript
14) Flex
15) Java
16) Java Book
17) Java by API
18) Java Tutorial
19) JavaScript DHTML
20) JavaScript Reference
21) JavaScript Tutorial
22) MSOfficeExcel 2007 Tutorial
23) MSOfficePowerPoint 2007 Tutorial
24) MSOfficeWord 2007 Tutorial
25) MSSQL
26) MSSQL Tutorial
27) MySQL
28) MySQL Tutorial
29) Oracle PLSQL
30) Oracle PLSQL Tutorial
31) Perl
32) Php
33) PostgreSQL
34) Python
35) Python Tutorial
36) Ruby
37) Silverlight
38) VB.Net
39) VB.Net by API
40) VB.Net Tutorial
41) Visual C++ .NET
42) VisualBasic Script
43) XML
44) XML Tutorial

 

MSSQL
1) Aggregate Functions
2) Analytical Functions
3) Constraints
4) Cursor
5) Data Set
6) Data Type
7) Database
8) Date Timezone
9) Index
10) Insert Delete Update
11) Math Functions
12) Select Query
13) Sequence
14) Store Procedure Function
15) String Functions
16) Subquery
17) System
18) Table
19) Table Joins
20) Transact SQL
21) Transaction
22) Trigger
23) View
24) XML

View
1) Altering Views
2) Column names in a view can be defined in the CREATE statement
3) Create a simple view and retrieve data from it
4) Create function with SCHEMABINDING option
5) CREATE VIEW myView WITH SCHEMABINDING
6) CREATE VIEW statement called SCHEMA BINDING tells SQL Server to check for dependencies and disallow any modifications that would viol
7) Create VIEW WITH ENCRYPTION
8) Create view after check the availability
9) Create view based on table-join query
10) Creating a View Using SQL Script and then drop it
11) Creating An INSTEAD OF DML Trigger
12) Data modification via views
13) Drop a view if it exists
14) Filter view with check option
15) Inline view as a column
16) More Complex Views
17) Nested view
18) Query data from a user view
19) Rename column when creating a view
20) Simple Views
21) Stored Procedures as Parameterized Views
22) The ALTER statement is issued with the revised view definition
23) Use view to filter out the NULL data
24) Using Derived Tables
25) Using the ORDER BY Clause in a View with a TOP Statement
26) View cannot be sorted with ORDER BY unless the TOP command is also used
27) When you create a view, youre really just naming a SQL SELECT statement
28) WITH CHECK OPTION keeps the results synchronized with the table(s)